At 7:05 PM -0400 8/27/07, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>> I assign the transaction object to each of the commands, but it seems
>> that some tables will get updated, even when I call rollback. Is
>> something I'm calling secretly calling "commit" somewhere?
>
>Dunno anything about vb.net, but this sounds like an autocommit feature
>that's not doing what you expect.
>
>If nothing else comes to mind, try setting the DB to log all statements
>(see log_statement), and compare the resulting trace to what you think
>your code is doing. That should at least narrow it down a lot.
>
> regards, tom lane
Thanks, I'll give that a try.
-Owen